Dataset statistics
| Number of variables | 6 |
|---|---|
| Number of observations | 243003 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 11.1 MiB |
| Average record size in memory | 48.0 B |
Variable types
| Numeric | 2 |
|---|---|
| Text | 2 |
| Categorical | 2 |
Reproduction
| Analysis started | 2024-06-03 00:45:16.781874 |
|---|---|
| Analysis finished | 2024-06-03 00:48:45.281106 |
| Duration | 3 minutes and 28.5 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
movie_id
Real number (ℝ)
| Distinct | 8884 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19916.397 |
| Minimum | 1 |
|---|---|
| Maximum | 193609 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 163 |
| Q1 | 1200 |
| median | 2993 |
| Q3 | 8880 |
| 95-th percentile | 99114 |
| Maximum | 193609 |
| Range | 193608 |
| Interquartile range (IQR) | 7680 |
Descriptive statistics
| Standard deviation | 34917.772 |
|---|---|
| Coefficient of variation (CV) | 1.7532174 |
| Kurtosis | 3.8101205 |
| Mean | 19916.397 |
| Median Absolute Deviation (MAD) | 2452 |
| Skewness | 2.0760662 |
| Sum | 4.8397441 × 109 |
| Variance | 1.2192508 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 356 | 1316 | 0.5% |
| 296 | 1228 | 0.5% |
| 1 | 1075 | 0.4% |
| 79132 | 1001 | 0.4% |
| 480 | 952 | 0.4% |
| 380 | 890 | 0.4% |
| 2959 | 872 | 0.4% |
| 593 | 837 | 0.3% |
| 780 | 808 | 0.3% |
| 260 | 753 | 0.3% |
| Other values (8874) | 233271 |
| Value | Count | Frequency (%) |
| 1 | 1075 | |
| 2 | 330 | 0.1% |
| 3 | 104 | < 0.1% |
| 4 | 21 | < 0.1% |
| 5 | 49 | < 0.1% |
| 6 | 306 | 0.1% |
| 7 | 108 | < 0.1% |
| 8 | 16 | < 0.1% |
| 9 | 16 | < 0.1% |
| 10 | 396 | 0.2% |
| Value | Count | Frequency (%) |
| 193609 | 1 | < 0.1% |
| 193587 | 2 | |
| 193585 | 1 | < 0.1% |
| 193583 | 3 | |
| 193573 | 1 | < 0.1% |
| 193571 | 2 | |
| 193567 | 2 | |
| 193565 | 4 | |
| 191005 | 4 | |
| 190221 | 1 | < 0.1% |
title
Text
| Distinct | 8881 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
Length
| Max length | 158 |
|---|---|
| Median length | 102 |
| Mean length | 25.068608 |
| Min length | 8 |
Characters and Unicode
| Total characters | 6091747 |
|---|---|
| Distinct characters | 120 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1135 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | Toy Story (1995) |
|---|---|
| 2nd row | Toy Story (1995) |
| 3rd row | Toy Story (1995) |
| 4th row | Toy Story (1995) |
| 5th row | Toy Story (1995) |
| Value | Count | Frequency (%) |
| the | 90154 | 9.0% |
| of | 26496 | 2.6% |
| 1995 | 15779 | 1.6% |
| 1994 | 13205 | 1.3% |
| 1996 | 11040 | 1.1% |
| and | 9837 | 1.0% |
| 1997 | 9687 | 1.0% |
| 1999 | 9643 | 1.0% |
| 2000 | 8947 | 0.9% |
| 2001 | 8903 | 0.9% |
| Other values (8960) | 803271 |
Most occurring characters
| Value | Count | Frequency (%) |
| 763997 | 12.5% | |
| e | 418818 | 6.9% |
| a | 279011 | 4.6% |
| ) | 261135 | 4.3% |
| ( | 261135 | 4.3% |
| 9 | 258428 | 4.2% |
| o | 254364 | 4.2% |
| r | 240613 | 3.9% |
| n | 231076 | 3.8% |
| t | 219672 | 3.6% |
| Other values (110) | 2903498 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6091747 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 763997 | 12.5% | |
| e | 418818 | 6.9% |
| a | 279011 | 4.6% |
| ) | 261135 | 4.3% |
| ( | 261135 | 4.3% |
| 9 | 258428 | 4.2% |
| o | 254364 | 4.2% |
| r | 240613 | 3.9% |
| n | 231076 | 3.8% |
| t | 219672 | 3.6% |
| Other values (110) | 2903498 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6091747 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 763997 | 12.5% | |
| e | 418818 | 6.9% |
| a | 279011 | 4.6% |
| ) | 261135 | 4.3% |
| ( | 261135 | 4.3% |
| 9 | 258428 | 4.2% |
| o | 254364 | 4.2% |
| r | 240613 | 3.9% |
| n | 231076 | 3.8% |
| t | 219672 | 3.6% |
| Other values (110) | 2903498 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6091747 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 763997 | 12.5% | |
| e | 418818 | 6.9% |
| a | 279011 | 4.6% |
| ) | 261135 | 4.3% |
| ( | 261135 | 4.3% |
| 9 | 258428 | 4.2% |
| o | 254364 | 4.2% |
| r | 240613 | 3.9% |
| n | 231076 | 3.8% |
| t | 219672 | 3.6% |
| Other values (110) | 2903498 |
genres
Categorical
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
| Drama | |
|---|---|
| Comedy | |
| Action | |
| Thriller | |
| Adventure | |
| Other values (15) |
Length
| Max length | 18 |
|---|---|
| Median length | 11 |
| Mean length | 6.4145422 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1558753 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Fantasy |
|---|---|
| 2nd row | Comedy |
| 3rd row | Children |
| 4th row | Animation |
| 5th row | Adventure |
Common Values
| Value | Count | Frequency (%) |
| Drama | 39562 | |
| Comedy | 34357 | |
| Action | 28910 | |
| Thriller | 25166 | |
| Adventure | 20459 | |
| Romance | 16405 | |
| Sci-Fi | 16114 | |
| Crime | 15428 | 6.3% |
| Fantasy | 9926 | 4.1% |
| Mystery | 7495 | 3.1% |
| Other values (10) | 29181 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| drama | 39562 | |
| comedy | 34357 | |
| action | 28910 | |
| thriller | 25166 | |
| adventure | 20459 | |
| romance | 16405 | |
| sci-fi | 16114 | |
| crime | 15428 | 6.3% |
| fantasy | 9926 | 4.1% |
| mystery | 7495 | 3.1% |
| Other values (12) | 29239 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 167891 | 10.8% |
| e | 149940 | 9.6% |
| a | 126238 | 8.1% |
| i | 116658 | 7.5% |
| m | 110284 | 7.1% |
| o | 98139 | 6.3% |
| n | 89641 | 5.8% |
| t | 72430 | 4.6% |
| c | 64756 | 4.2% |
| d | 60309 | 3.9% |
| Other values (24) | 502467 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1558753 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 167891 | 10.8% |
| e | 149940 | 9.6% |
| a | 126238 | 8.1% |
| i | 116658 | 7.5% |
| m | 110284 | 7.1% |
| o | 98139 | 6.3% |
| n | 89641 | 5.8% |
| t | 72430 | 4.6% |
| c | 64756 | 4.2% |
| d | 60309 | 3.9% |
| Other values (24) | 502467 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1558753 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 167891 | 10.8% |
| e | 149940 | 9.6% |
| a | 126238 | 8.1% |
| i | 116658 | 7.5% |
| m | 110284 | 7.1% |
| o | 98139 | 6.3% |
| n | 89641 | 5.8% |
| t | 72430 | 4.6% |
| c | 64756 | 4.2% |
| d | 60309 | 3.9% |
| Other values (24) | 502467 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1558753 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 167891 | 10.8% |
| e | 149940 | 9.6% |
| a | 126238 | 8.1% |
| i | 116658 | 7.5% |
| m | 110284 | 7.1% |
| o | 98139 | 6.3% |
| n | 89641 | 5.8% |
| t | 72430 | 4.6% |
| c | 64756 | 4.2% |
| d | 60309 | 3.9% |
| Other values (24) | 502467 |
director_name
Text
| Distinct | 3567 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
Length
| Max length | 32 |
|---|---|
| Median length | 24 |
| Mean length | 13.11799 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3187711 |
|---|---|
| Distinct characters | 87 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 454 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | John Lasseter |
|---|---|
| 2nd row | John Lasseter |
| 3rd row | John Lasseter |
| 4th row | John Lasseter |
| 5th row | John Lasseter |
| Value | Count | Frequency (%) |
| john | 11057 | 2.2% |
| david | 8243 | 1.6% |
| steven | 7649 | 1.5% |
| robert | 7533 | 1.5% |
| james | 5991 | 1.2% |
| spielberg | 5921 | 1.2% |
| peter | 5324 | 1.1% |
| michael | 5126 | 1.0% |
| richard | 4817 | 1.0% |
| george | 4325 | 0.9% |
| Other values (4210) | 435383 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 312830 | 9.8% |
| 258366 | 8.1% | |
| n | 243777 | 7.6% |
| a | 237911 | 7.5% |
| r | 225611 | 7.1% |
| o | 197679 | 6.2% |
| i | 177977 | 5.6% |
| l | 129614 | 4.1% |
| t | 117414 | 3.7% |
| s | 105499 | 3.3% |
| Other values (77) | 1181033 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3187711 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 312830 | 9.8% |
| 258366 | 8.1% | |
| n | 243777 | 7.6% |
| a | 237911 | 7.5% |
| r | 225611 | 7.1% |
| o | 197679 | 6.2% |
| i | 177977 | 5.6% |
| l | 129614 | 4.1% |
| t | 117414 | 3.7% |
| s | 105499 | 3.3% |
| Other values (77) | 1181033 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3187711 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 312830 | 9.8% |
| 258366 | 8.1% | |
| n | 243777 | 7.6% |
| a | 237911 | 7.5% |
| r | 225611 | 7.1% |
| o | 197679 | 6.2% |
| i | 177977 | 5.6% |
| l | 129614 | 4.1% |
| t | 117414 | 3.7% |
| s | 105499 | 3.3% |
| Other values (77) | 1181033 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3187711 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 312830 | 9.8% |
| 258366 | 8.1% | |
| n | 243777 | 7.6% |
| a | 237911 | 7.5% |
| r | 225611 | 7.1% |
| o | 197679 | 6.2% |
| i | 177977 | 5.6% |
| l | 129614 | 4.1% |
| t | 117414 | 3.7% |
| s | 105499 | 3.3% |
| Other values (77) | 1181033 |
user_id
Real number (ℝ)
| Distinct | 610 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 325.57233 |
| Minimum | 1 |
|---|---|
| Maximum | 610 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.9 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 32 |
| Q1 | 177 |
| median | 325 |
| Q3 | 477 |
| 95-th percentile | 600 |
| Maximum | 610 |
| Range | 609 |
| Interquartile range (IQR) | 300 |
Descriptive statistics
| Standard deviation | 182.34269 |
|---|---|
| Coefficient of variation (CV) | 0.56006816 |
| Kurtosis | -1.1758802 |
| Mean | 325.57233 |
| Median Absolute Deviation (MAD) | 150 |
| Skewness | -0.074420324 |
| Sum | 79115052 |
| Variance | 33248.858 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 414 | 6082 | 2.5% |
| 599 | 5659 | 2.3% |
| 448 | 4313 | 1.8% |
| 474 | 4294 | 1.8% |
| 610 | 3326 | 1.4% |
| 274 | 3317 | 1.4% |
| 380 | 3316 | 1.4% |
| 68 | 3080 | 1.3% |
| 249 | 2697 | 1.1% |
| 606 | 2468 | 1.0% |
| Other values (600) | 204451 |
| Value | Count | Frequency (%) |
| 1 | 595 | |
| 2 | 75 | < 0.1% |
| 3 | 89 | < 0.1% |
| 4 | 444 | |
| 5 | 95 | < 0.1% |
| 6 | 673 | |
| 7 | 398 | |
| 8 | 123 | 0.1% |
| 9 | 97 | < 0.1% |
| 10 | 324 |
| Value | Count | Frequency (%) |
| 610 | 3326 | |
| 609 | 89 | < 0.1% |
| 608 | 2025 | |
| 607 | 472 | 0.2% |
| 606 | 2468 | |
| 605 | 638 | 0.3% |
| 604 | 242 | 0.1% |
| 603 | 2012 | |
| 602 | 328 | 0.1% |
| 601 | 240 | 0.1% |
rating
Categorical
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.9 MiB |
| 4.0 | |
|---|---|
| 3.0 | |
| 3.5 | |
| 5.0 | |
| 4.5 | |
| Other values (5) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 729009 |
|---|---|
| Distinct characters | 7 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 4.0 |
|---|---|
| 2nd row | 4.0 |
| 3rd row | 4.0 |
| 4th row | 4.0 |
| 5th row | 4.0 |
Common Values
| Value | Count | Frequency (%) |
| 4.0 | 64254 | |
| 3.0 | 48532 | |
| 3.5 | 31965 | |
| 5.0 | 31733 | |
| 4.5 | 20971 | 8.6% |
| 2.0 | 18189 | 7.5% |
| 2.5 | 13242 | 5.4% |
| 1.0 | 6611 | 2.7% |
| 1.5 | 4204 | 1.7% |
| 0.5 | 3302 | 1.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 4.0 | 64254 | |
| 3.0 | 48532 | |
| 3.5 | 31965 | |
| 5.0 | 31733 | |
| 4.5 | 20971 | 8.6% |
| 2.0 | 18189 | 7.5% |
| 2.5 | 13242 | 5.4% |
| 1.0 | 6611 | 2.7% |
| 1.5 | 4204 | 1.7% |
| 0.5 | 3302 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| . | 243003 | |
| 0 | 172621 | |
| 5 | 105417 | |
| 4 | 85225 | 11.7% |
| 3 | 80497 | 11.0% |
| 2 | 31431 | 4.3% |
| 1 | 10815 | 1.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 729009 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| . | 243003 | |
| 0 | 172621 | |
| 5 | 105417 | |
| 4 | 85225 | 11.7% |
| 3 | 80497 | 11.0% |
| 2 | 31431 | 4.3% |
| 1 | 10815 | 1.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 729009 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| . | 243003 | |
| 0 | 172621 | |
| 5 | 105417 | |
| 4 | 85225 | 11.7% |
| 3 | 80497 | 11.0% |
| 2 | 31431 | 4.3% |
| 1 | 10815 | 1.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 729009 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| . | 243003 | |
| 0 | 172621 | |
| 5 | 105417 | |
| 4 | 85225 | 11.7% |
| 3 | 80497 | 11.0% |
| 2 | 31431 | 4.3% |
| 1 | 10815 | 1.5% |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| movie_id | title | genres | director_name | user_id | rating | |
|---|---|---|---|---|---|---|
| 0 | 1 | Toy Story (1995) | Fantasy | John Lasseter | 1 | 4.0 |
| 1 | 1 | Toy Story (1995) | Comedy | John Lasseter | 1 | 4.0 |
| 2 | 1 | Toy Story (1995) | Children | John Lasseter | 1 | 4.0 |
| 3 | 1 | Toy Story (1995) | Animation | John Lasseter | 1 | 4.0 |
| 4 | 1 | Toy Story (1995) | Adventure | John Lasseter | 1 | 4.0 |
| 5 | 3 | Grumpier Old Men (1995) | Romance | Howard Deutch | 1 | 4.0 |
| 6 | 3 | Grumpier Old Men (1995) | Comedy | Howard Deutch | 1 | 4.0 |
| 7 | 6 | Heat (1995) | Thriller | Michael Mann | 1 | 4.0 |
| 8 | 6 | Heat (1995) | Crime | Michael Mann | 1 | 4.0 |
| 9 | 6 | Heat (1995) | Action | Michael Mann | 1 | 4.0 |
| movie_id | title | genres | director_name | user_id | rating | |
|---|---|---|---|---|---|---|
| 242993 | 168248 | John Wick: Chapter Two (2017) | Thriller | Chad Stahelski | 610 | 5.0 |
| 242994 | 168248 | John Wick: Chapter Two (2017) | Crime | Chad Stahelski | 610 | 5.0 |
| 242995 | 168248 | John Wick: Chapter Two (2017) | Action | Chad Stahelski | 610 | 5.0 |
| 242996 | 168250 | Get Out (2017) | Horror | Jordan Peele | 610 | 5.0 |
| 242997 | 168252 | Logan (2017) | Sci-Fi | James Mangold | 610 | 5.0 |
| 242998 | 168252 | Logan (2017) | Action | James Mangold | 610 | 5.0 |
| 242999 | 170875 | The Fate of the Furious (2017) | Thriller | F. Gary Gray | 610 | 3.0 |
| 243000 | 170875 | The Fate of the Furious (2017) | Drama | F. Gary Gray | 610 | 3.0 |
| 243001 | 170875 | The Fate of the Furious (2017) | Crime | F. Gary Gray | 610 | 3.0 |
| 243002 | 170875 | The Fate of the Furious (2017) | Action | F. Gary Gray | 610 | 3.0 |